vba中需要把“???.*.?”的单元格替换掉其中的"."为"/",然后更改单元格...答:a = Split(Cells(i, 1).Value, ".")(0)b = Split(Cells(i, 1).Value, ".")(1)c = Split(Cells(i, 1).Value, ".")(2)Cells(i, 3).Value = a & "/" & b & "/" & c Cells(i, 3).NumberFormatLocal = "yyyy/m/d;@"Next 希望能帮到你,for i=1 to 18中的18...